CREATING LINE AND CLUSTRED CHART 2&3 14

Create line and clustered column chart for GPM% and YOY% by Segment  

STPE 1- Copy and paste the previous line and clustered column chart.

STEP 2- Go to General, x position = 832, y position = 468, width = 668, height = 339

STEP 3 - Remove month from the shared axis and drag and drop Segment from sales table 

STEP 4- Go to format, click title change month to segment 

Follow the GIF below to apply the above steps


Create line and clustered column chart for GPM% and YOY% by Category and subcategory 

STPE 1- Copy and paste the previous line and clustered column chart.

STEP 2- Create hierarchy put subcategory under category so we can make drill through.

STEP 3 - Remove month from the shared axis and drag and drop category hierarchy from sales 

STEP 4- Go to format, click title change month to segment. 

Follow the GIF below to apply the above steps


Final Step we need to add YOY% tooltip for all 3 line and clustered column chart 

Follow the GIF below to apply the above steps




EVERYTHING you wanted to know about Power BI tooltips